Enquiry_Parts Tables

The accounts_changelog and accounts_latest tables stores the data of all supplier groups, including contact details, location, services offered and permissions assigned to them.

---

🔹 Standard Columns

Column Name	Data Type	Nullable	Description
document_name	STRING	YES	Name of the document.
document_event_id	STRING	YES	Unique event ID associated with this document.
document_timestamp	TIMESTAMP	YES	Timestamp when the document event occurred.
document_operation	STRING	YES	Type of operation (e.g., INSERT, UPDATE, DELETE).
document_id	STRING	YES	Unique identifier for the document.
accountId	STRING	YES	Account identifier.
serviceUnitId	STRING	YES	Service Unit identifier.
enquiryId	STRING	YES	Related Enquiry ID.

---

🔸 Array Columns

partLines

Array of STRUCT

Column Name	Data Type	Nullable	Description
lineType	STRING	YES	Type of line (e.g., fluid, part).
manufacturerGoodwill	STRUCT	YES	Goodwill information provided by the manufacturer.
manufacturerGoodwill.masked	STRING	YES	Masked display value.
manufacturerGoodwill.raw	FLOAT64	YES	Raw goodwill amount.
name	STRING	YES	Name of the part.
netPrice	STRUCT	YES	Net price details.
netPrice.masked	STRING	YES	Masked price.
netPrice.raw	STRING	YES	Raw price as string.
netPrice.value	FLOAT64	YES	Price value.
number	STRING	YES	Part number.
quantity	STRUCT	YES	Quantity details.
quantity.masked	STRING	YES	Masked quantity.
quantity.raw	INT64	YES	Actual quantity.
unitDiscount	STRUCT	YES	Discount per unit.
unitDiscount.masked	STRING	YES	Masked discount.
unitDiscount.raw	FLOAT64	YES	Raw discount.
unitDiscount.value	FLOAT64	YES	Discount value.
unitDiscount.warning	BOOL	YES	Whether there’s a discount warning.
unitPrice	STRUCT	YES	Unit price details.
unitPrice.masked	STRING	YES	Masked unit price.
unitPrice.raw	FLOAT64	YES	Raw unit price.
unitPrice.value	FLOAT64	YES	Unit price value.

deletedPartLines

Array of STRUCT

Column Name	Data Type	Nullable	Description
lineType	STRING	YES	Type of line (e.g., fluid, part).
manufacturerGoodwill	STRUCT	YES	Goodwill information provided by the manufacturer.
manufacturerGoodwill.masked	STRING	YES	Masked display value.
manufacturerGoodwill.raw	FLOAT64	YES	Raw goodwill amount.
name	STRING	YES	Name of the part.
netPrice	STRUCT	YES	Net price details.
netPrice.masked	STRING	YES	Masked price.
netPrice.raw	STRING	YES	Raw price as string.
netPrice.value	FLOAT64	YES	Price value.
number	STRING	YES	Part number.
quantity	STRUCT	YES	Quantity details.
quantity.masked	STRING	YES	Masked quantity.
quantity.raw	INT64	YES	Actual quantity.
unitDiscount	STRUCT	YES	Discount per unit.
unitDiscount.masked	STRING	YES	Masked discount.
unitDiscount.raw	FLOAT64	YES	Raw discount.
unitDiscount.value	FLOAT64	YES	Discount value.
unitDiscount.warning	BOOL	YES	Whether there’s a discount warning.
unitPrice	STRUCT	YES	Unit price details.
unitPrice.masked	STRING	YES	Masked unit price.
unitPrice.raw	FLOAT64	YES	Raw unit price.
unitPrice.value	FLOAT64	YES	Unit price value.